USE [RD_FixedAssetsMart]
GO

/****** Object:  Index [PK_FA_Star_AssetMaster]    Script Date: 01/26/2011 14:55:02 ******/
ALTER TABLE [dbo].[FA_Star_AssetMaster] ADD  CONSTRAINT [PK_FA_Star_AssetMaster] PRIMARY KEY CLUSTERED 
(
	[AssetItemNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


USE [RD_FixedAssetsMart]
GO

/****** Object:  Index [IX_AssetMaster_AssetItemNumberID]    Script Date: 01/26/2011 14:54:41 ******/
CREATE NONCLUSTERED INDEX [IX_AssetMaster_AssetItemNumberID] ON [dbo].[FA_Star_AssetMaster] 
(
	[AssetItemNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_AssetMaster_ParentNumber]    Script Date: 01/26/2011 14:54:41 ******/
CREATE NONCLUSTERED INDEX [IX_AssetMaster_ParentNumber] ON [dbo].[FA_Star_AssetMaster] 
(
	[ParentNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_271]    Script Date: 01/26/2011 14:54:42 ******/
CREATE NONCLUSTERED INDEX [missing_index_271] ON [dbo].[FA_Star_AssetMaster] 
(
	[AddressNumberLessorRentorMort] ASC
)
INCLUDE ( [UnitorTagNumber],
[SerialNumber],
[Description01],
[Description03]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_273]    Script Date: 01/26/2011 14:54:42 ******/
CREATE NONCLUSTERED INDEX [missing_index_273] ON [dbo].[FA_Star_AssetMaster] 
(
	[AddressNumberLessorRentorMort] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_40]    Script Date: 01/26/2011 14:54:42 ******/
CREATE NONCLUSTERED INDEX [missing_index_40] ON [dbo].[FA_Star_AssetMaster] 
(
	[SerialNumber] ASC,
	[EquipmentStatus] ASC,
	[Category08Code] ASC
)
INCLUDE ( [BusinessUnitCode],
[Description03],
[AddressNumberLessorRentorMort]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_592]    Script Date: 01/26/2011 14:54:42 ******/
CREATE NONCLUSTERED INDEX [missing_index_592] ON [dbo].[FA_Star_AssetMaster] 
(
	[AddressNumberLessorRentorMort] ASC
)
INCLUDE ( [UnitorTagNumber],
[SerialNumber],
[Description01],
[Description03],
[StartEffectiveDate]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


